Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


TSreorg from Platinum Technologies

TSreorg is a graphical tool designed specifically to monitor the structure of your database and to reorganize and defragment the objects in your database to maximize I/O performance. Although TSreorg performs other functions such as job monitoring and scheduling, the real beauty of this product is its ability to reorganize and defragment. Platinum Technologies also offers an excellent suite of system-management products.

Precise/SQL Suite from Precise Software Solutions

Precise Software Solutions offer two tools to help analyze problems within your applications:

  Inspect/SQL. Used to identify problems within applications themselves.
  Analyze/SQL. Used to analyze problems and model potential improvements.

This product is interesting because it focuses on the client application, which is where many performance problems originate.

DATA-XPERT from Compuware

DATA-XPERT is a useful tool for testing a database that has not yet gone into production. DATA-XPERT is designed to create sample data you can use to test your database. By using a tool like this to generate good quality test data, you can find and fix potential problems before your database and applications are deployed.

AdHawk from Eventus

Although AdHawk is usually considered a database monitoring tool, it can offer specific recommendations for resolving database problems that may occur. Eventus also offers AdHawk Spacer, a tool that provides for database reorganization and management.

DBGENERAL from Bradmark

Although Bradmark’s DBGENERAL is also primarily seen as a database monitoring tool, the most recent release has increased its functionality. DBGENERAL now provides for reorganization, defragmentation, and capacity management as well as object management.

Patrol from BMC

Patrol is a powerful tool for monitoring and alerting based on events. Patrol uses knowledge modules to monitor certain events and to communicate with the Patrol console. You can use these knowledge modules to create your own events within the application itself. In this manner, you can monitor every aspect of your system.

Summary of Analysis Tools

As you have seen in the preceding sections, a number of excellent products are on the market to help with various aspects of managing your system and detecting and removing performance bottlenecks. When you take advantage of these tools, your system can continue to perform optimally after deployment.

Remember that the job of optimizing and tuning your system does not stop once the system goes into production. It is an ongoing job to keep your machine tuned and running well at all times. The best way to solve performance problems in production systems is to identify and fix any problems before they start affecting users. In this way, you can avoid costly downtime and loss of work.

Summary

By taking advantage of SQL development tools for the design of your database, the development of your applications, and for analyzing the outcome of your applications, you can facilitate the optimization of your system. Database design tools can be used to determine where the use of clusters or indexes can help the efficiency of the system. Application development tools can help you rapidly develop, prototype, and deploy graphical applications with a minimal amount of effort.

Other tools available on the market can perform specific functions to help remove some of the bottlenecks they discover. Some of these tools perform defragmentation functions; others reorganize database objects for optimal I/O performance. The use of such tools to keep your system running optimally outweighs the purchase price of these products. Performance tuning and optimization does not stop when the system is deployed; it is a ongoing job that can be assisted by the use of the right tool.

The use of SQL analysis and tracing tools can assist you in tracking down problem areas and bottlenecks in both the database server and the application. This capability can be useful not only in indicating the cause of a performance problem or bottleneck but also in ruling out areas in question. Performance problems can be associated with the client, the server, or a combination of the two. SQL tracing tools facilitate the determination of the problem and may lead to a solution.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.